[dbo].[BAEGetAllEvents]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEGetAllEvents
Properties
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
SQL Script
create
procedure
[dbo]
.
[BAEGetAllEvents]
as
SELECT
*
FROM
Meet_Master
WHERE
WEB_ENABLED
=
'1'
AND
STATUS
=
'A'
AND
(
BEGIN_DATE
>
GETDATE
()
OR
END_DATE
>=
GETDATE
())
ORDER
BY
BEGIN_DATE
;
GO
Uses
[dbo].[Meet_Master]
dbo